SharePoint Server for Business Intelligence by Unknown

Author:Unknown
Language: eng
Format: epub, mobi
Publisher: Microsoft Press BPD
Published: 2012-04-05T04:00:00+00:00

To embed external data connection information in an Excel workbook

1. In Excel 2010, on the Data tab, in the Connections group, click Connections. The Workbook Connections dialog box opens.

2. Select the Contoso-sql ContosoRetailDW DimStore connection, and then click Properties.

The Connection Properties dialog box opens.

3. Select the Definition tab.

4. In the Excel Services section, click Authentication Settings.

The Excel Services Authentication Settings dialog box opens.

5. Select SSS, and in the SSS ID box, type ExcelServicesEmbeddedData.

6. Click OK to close the Excel Services Authentication Settings dialog box, and then click OK to close the Connection Properties dialog box.

7. If a warning appears that states that the link to the external odc file will be removed, click Yes.

8. In the Workbook Connections dialog box, click Close. Do not close the workbook yet.

At this point, we have created a workbook that contains an embedded data connection. The next step is to publish the workbook to SharePoint Server.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.